<html>
<head>
    <title>clos</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf8">
    <style type="text/css">
        body {
            font-family: "微软雅黑", Verdana, Arial, Helvetica, sans-serif;
            margin: 0;
            padding: 0;
            overflow: hidden;
        }

        .normal {
            font-size: 11px;
            font-weight: normal;
            color: #000000;
            overflow-wrap: break-word;
        }

        .fieldcolumn {
            color: #000000;
            font-size: 10px;
            font-weight: 600;
            background-color: #ffffff;
        }

        .keycolumn {

        }

        .c1, .k1 {
            width: 330px;
        }

        .c2 {
            width: 150px;
        }

        .c3 {
            width: 100px;
        }

        .k2 {
            width: 250px;
        }

        .c4, .k3 {
            width: 100px;
        }

        .c5 {
            width: 100px;
        }

        .c6 {
            width: 500px;
        }

        .main-wrapper {

        }

        .container {
            display: table;
            height: 100%;
            width: 100%;
        }

        .left-content {
            width: 300px;
            display: table-cell;
            border-right: 1px solid #ccc;
            border-collapse: collapse;
        }

        .left-content .search {
            height: 30px;
            padding: 0 4px;
            border-bottom: 1px solid #aeaeae;
        }

        .left-content .search .search-div {

        }

        .left-content .search-input {
            width: 230px;
            height: 25px;
            overflow: scroll;
        }

        .left-content .search-button {
            width: 50px;
            margin-left: 6px;
            height: 25px;
        }

        .left-content .tables::-webkit-scrollbar {
            width: 6px;
        }

        .right-content {
            height: 100%;
        }

        .right-content .title {
            height: 34px;
            width: 100%;
            overflow: hidden;
            text-align: center;
            margin: 0 auto;
            vertical-align: middle;
            border-bottom: 1px solid #aeaeae;
        }

        .right-content .title span {
            display: inline-block;
            height: 32px;
            line-height: 32px;
            width: 100%;
            font-weight: bold;
        }

        .right-content .tables {
            padding: 5px 5px 20px;
            overflow: scroll;
        }

        .right-content .tables table {
            margin-bottom: 5px;
        }

        .right-content .tables table tr:first-child {
            font-weight: bold;
            background: #c6ffd2;
        }

        .right-content .tables::-webkit-scrollbar {
            width: 6px;
        }

        table {
            font-size: 14px;
            color: #444;
            border-spacing: 0;
            border: 1px solid grey;
            border-collapse: separate;
        }

        table.table-content th, tr, td {
            padding: 4px;
        }

        table.key {
            margin-bottom: 15px!important;
        }

        table.key tr:first-child td, table.key tr:first-child td p {
            background: #7dc0f9;
        }

        ::-webkit-scrollbar-button {
            display: none;
        }

        ::-webkit-scrollbar-thumb {
            background-color: #e1e1e1;
            border-radius: 4px;
        }

        ::-webkit-scrollbar-thumb:hover {
            background-color: #c1c1c1;
        }

        ::-webkit-scrollbar-track {
            background-color: initial;
        }

    </style>
</head>
<body>

<div class="main-wrapper">
    <div class="container">
        <div class="left-content">
            <div class="search">
                <div class="search-div">
                    <input id="search-input" class="search-input" type="text" placeholder="输入关键字进行搜索"/>
                    <input id="search-button" class="search-button" type="button" value="搜索"/>
                </div>
            </div>
            <div class="navlink">
                <ul>
                    <li>
                        <a href="javascript:scrollTo('aicc_bill')">
                            <p class="normal">
                                aicc_bill
                                (--)
                        </a>
                    </li>
                    <li>
                        <a href="javascript:scrollTo('aicc_bill_copy1');">
                            <p class="normal">
                                aicc_bill_copy1
                                (--)
                        </a>
                    </li>
                    <li>
                        <a href="javascript:scrollTo('aicc_bill_task');">
                            <p class="normal">
                                aicc_bill_task
                                (软电话通话记录)
                        </a>
                    </li>
                    <li>
                        <a href="javascript:scrollTo('aicc_video_file');">
                            <p class="normal">
                                aicc_video_file
                                (--)
                        </a>
                    </li>
                </ul>
            </div>
        </div>
        <div class="right-content">
            <div id="title" class="title">
                <span>clos表结构列表</span>
            </div>
            <div id="tables" class="tables">
                <table id="aicc_bill" class="table-content" width="100%" cellspacing="0" cellapdding="2" border="1">
                    <tr>
                        <td colspan="5">aicc_bill(--)</td>
                    </tr>
                    <tr>
                        <td align="center" valign="top" class="fieldcolumn c1">名称</td>
                        <td align="center" valign="top" class="fieldcolumn c2">类型</td>
                        <td align="center" valign="top" class="fieldcolumn c3">是否可为空</td>
                        <td align="center" valign="top" class="fieldcolumn c4">默认值</td>
                        <td align="center" valign="top" class="fieldcolumn c6">注释</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">id</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">NO</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal"></td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">vccid</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">企业标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">type</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">话单类型(来源:1山东通服;2华为)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">call_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(63)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫编号(序号)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">sid</td>
                        <td align="left" valign="top"><p class="normal">varchar(63)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫流水号</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">direction</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫方向(1外线呼入;2外线呼出;3内线呼入;4内线呼出)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">disconnection</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">挂机方(1主叫;2被叫)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">unique_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">唯一标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">user_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">部门/班组号</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">cdr_type</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">cdr话单类型</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">call_type</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫类型</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">agent_number</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">坐席号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">start_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">开始时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">answer_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">应答时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">end_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">结束时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">bridge_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">接通时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">bridge_duration</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">通话时长(单位s)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">total_duration</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">总时长(单位s)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">status</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">接听状态</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">record_file</td>
                        <td align="left" valign="top"><p class="normal">varchar(300)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">录音文件地址</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">end_reason</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">挂机状态</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">cno</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">坐席标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">agent_name</td>
                        <td align="left" valign="top"><p class="normal">varchar(50)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">坐席名称</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">qno</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">....</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">customer_number</td>
                        <td align="left" valign="top"><p class="normal">varchar(150)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">客户号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">push_cdr_status</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">推送话单状态</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">push_cdr_hit_strategy</td>
                        <td align="left" valign="top"><p class="normal">varchar(50)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">推送话单命中转写策略</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">clean_status</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">......</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">pull_record_num</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">......</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">pull_record_status</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">......</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">receive_time</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">......</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">origcalltype</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫类型</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">origcalling</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">原始主叫号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">origcalled</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">原始主叫号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">destnumber</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">原始主叫号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">destsid</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">转移标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">detail</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫结果明细</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">queuesec</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">排队时长</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">taskid</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">服务(任务)标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">service</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">服务类型</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">postprocess</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">后处理时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">transparam</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">透明参数</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">msserver</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">所在的媒体服务器名称</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">calldata</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">随路数据</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">areacode</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">区号</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">telthree</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">区号或手机前三位</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">telseven</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">区号或手机前七位</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">orderid</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">单号/流水号</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">create_time</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">记录创建时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">priority</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">优先信息</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">inc_day</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">增量日期</td>
                    </tr>
                </table>

                <table class="table-content key" width="50%" cellspacing="0" cellapdding="2" border="1">
                    <tr>
                        <td class="k1" align="left" valign="top"><p class="fieldcolumn keycolumn">Indexes</p></td>
                        <td class="k2" align="left" valign="top"><p class="fieldcolumn keycolumn">Columns</p></td>
                        <td class="k3" align="left" valign="top"><p class="fieldcolumn keycolumn">Index Type</p></td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal" style="color:red">PRIMARY</p></td>
                        <td align="left" valign="top"><p class="normal">computer_id</p></td>
                        <td align="left" valign="top"><p class="normal">Unique</p></td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">computer_code</p></td>
                        <td align="left" valign="top"><p class="normal">computer_code</p></td>
                        <td align="left" valign="top"><p class="normal">Unique</p></td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">index_depot_code</p></td>
                        <td align="left" valign="top"><p class="normal">depot_code</p></td>
                        <td align="left" valign="top"><p class="normal"></p></td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">idx_computer_level_function</p></td>
                        <td align="left" valign="top"><p class="normal">computer_level, default_function</p></td>
                        <td align="left" valign="top"><p class="normal"></p></td>
                    </tr>
                </table>

                <table id="aicc_bill_copy1" class="table-content" width="100%" cellspacing="0" cellapdding="2" border="1">
                    <tr>
                        <td colspan="5">
                            aicc_bill_copy1 (--)
                        </td>
                    </tr>
                    <tr>
                        <td align="center" valign="top" class="fieldcolumn c1">名称</td>
                        <td align="center" valign="top" class="fieldcolumn c2">类型</td>
                        <td align="center" valign="top" class="fieldcolumn c3">是否可为空</td>
                        <td align="center" valign="top" class="fieldcolumn c4">默认值</td>
                        <td align="center" valign="top" class="fieldcolumn c6">注释</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">id</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">NO</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal"></td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">vccid</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">企业标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">type</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">话单类型(来源:1山东通服;2华为)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">call_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(63)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫编号(序号)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">sid</td>
                        <td align="left" valign="top"><p class="normal">varchar(63)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫流水号</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">direction</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫方向(1外线呼入;2外线呼出;3内线呼入;4内线呼出)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">disconnection</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">挂机方(1主叫;2被叫)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">unique_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">唯一标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">user_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">部门/班组号</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">cdr_type</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">cdr话单类型</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">call_type</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫类型</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">agent_number</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">坐席号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">start_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">开始时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">answer_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">应答时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">end_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">结束时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">bridge_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">接通时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">bridge_duration</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">通话时长(单位s)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">total_duration</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">总时长(单位s)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">status</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">接听状态</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">record_file</td>
                        <td align="left" valign="top"><p class="normal">varchar(300)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">录音文件地址</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">end_reason</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">挂机状态</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">cno</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">坐席标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">agent_name</td>
                        <td align="left" valign="top"><p class="normal">varchar(50)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">坐席名称</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">qno</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">....</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">customer_number</td>
                        <td align="left" valign="top"><p class="normal">varchar(150)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">客户号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">push_cdr_status</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">推送话单状态</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">push_cdr_hit_strategy</td>
                        <td align="left" valign="top"><p class="normal">varchar(50)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">推送话单命中转写策略</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">clean_status</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">......</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">pull_record_num</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">......</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">pull_record_status</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">......</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">receive_time</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">......</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">origcalltype</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫类型</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">origcalling</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">原始主叫号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">origcalled</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">原始主叫号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">destnumber</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">原始主叫号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">destsid</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">转移标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">detail</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫结果明细</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">queuesec</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">排队时长</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">taskid</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">服务(任务)标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">service</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">服务类型</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">postprocess</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">后处理时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">transparam</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">透明参数</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">msserver</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">所在的媒体服务器名称</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">calldata</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">随路数据</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">areacode</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">区号</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">telthree</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">区号或手机前三位</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">telseven</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">区号或手机前七位</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">orderid</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">单号/流水号</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">create_time</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">记录创建时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">priority</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">优先信息</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">inc_day</td>
                        <td align="left" valign="top"><p class="normal">varchar(30)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">增量日期</td>
                    </tr>
                </table>
                <table id="aicc_bill_task" class="table-content" width="100%" cellspacing="0" cellapdding="2"
                       border="1">
                    <tr>
                        <td colspan="5">
                            aicc_bill_task (软电话通话记录)
                        </td>
                    </tr>
                    <tr>
                        <td align="center" valign="top" class="fieldcolumn c1">名称</td>
                        <td align="center" valign="top" class="fieldcolumn c2">类型</td>
                        <td align="center" valign="top" class="fieldcolumn c3">是否可为空</td>
                        <td align="center" valign="top" class="fieldcolumn c4">默认值</td>
                        <td align="center" valign="top" class="fieldcolumn c6">注释</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">id</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">NO</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">自增字段</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">vccid</td>
                        <td align="left" valign="top"><p class="normal">varchar(20)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">企业标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">type</td>
                        <td align="left" valign="top"><p class="normal">varchar(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">话单类型(来源:1山东通服;2华为)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">call_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(63)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫编号(序号)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">sid</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫流水号</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">unique_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">唯一标识</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">user_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(20)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">部门/班组号</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">call_type</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫类型</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">agent_number</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">坐席号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">start_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">开始时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">answer_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">应答时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">end_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">结束时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">bridge_time</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">接通时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">bridge_duration</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">通话时长(单位s)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">total_duration</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">总时长(单位s)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">record_file</td>
                        <td align="left" valign="top"><p class="normal">varchar(300)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">录音文件地址</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">agent_name</td>
                        <td align="left" valign="top"><p class="normal">varchar(20)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">坐席名称</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">customer_number</td>
                        <td align="left" valign="top"><p class="normal">varchar(150)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">客户号码</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">receive_time</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">......</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">detail</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">呼叫结果明细</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">create_time</td>
                        <td align="left" valign="top"><p class="normal">varchar(100)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">记录创建时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">inc_day</td>
                        <td align="left" valign="top"><p class="normal">varchar(255)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">增量日期</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">handle_status</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal">0</td>
                        <td align="left" valign="top"><p class="normal">处理状态（0.未处理 1.处理中 2.已完成）</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">handler_name</td>
                        <td align="left" valign="top"><p class="normal">varchar(20)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">处理人</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">handle_time</td>
                        <td align="left" valign="top"><p class="normal">datetime(0)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">处理时间</td>
                    </tr>
                </table>

                <table id="aicc_video_file" class="table-content" width="100%" cellspacing="0" cellapdding="2"
                       border="1">
                    <tr>
                        <td colspan="5">
                            aicc_video_file (--)
                        </td>
                    </tr>
                    <tr>
                        <td align="center" valign="top" class="fieldcolumn c1">名称</td>
                        <td align="center" valign="top" class="fieldcolumn c2">类型</td>
                        <td align="center" valign="top" class="fieldcolumn c3">是否可为空</td>
                        <td align="center" valign="top" class="fieldcolumn c4">默认值</td>
                        <td align="center" valign="top" class="fieldcolumn c6">注释</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">id</td>
                        <td align="left" valign="top"><p class="normal">bigint(19)</td>
                        <td align="left" valign="top"><p class="normal">NO</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">自增字段</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">product_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(15)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">产品id</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">record_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(63)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">记录id</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">session_id</td>
                        <td align="left" valign="top"><p class="normal">varchar(63)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">任务id(唯一标识)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">path_type</td>
                        <td align="left" valign="top"><p class="normal">varchar(7)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">路径类型(uri:默认值;oss:思必驰oss;file:本地文件)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">path</td>
                        <td align="left" valign="top"><p class="normal">varchar(10000)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">文件路径</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">priority</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">优先级</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">status</td>
                        <td align="left" valign="top"><p class="normal">varchar(7)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">
                            状态(0初始化;1正在上传;2上传完成;3正在处理;5处理成功;10未知错误;11文件下载错误;12文件转码错误;13文件读取错误;14VAD错误;15ASR错误)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">duration</td>
                        <td align="left" valign="top"><p class="normal">int(10)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">录音总时长(毫秒)</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">recv_time</td>
                        <td align="left" valign="top"><p class="normal">datetime(0)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">接收到任务的时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">deal_begin_time</td>
                        <td align="left" valign="top"><p class="normal">datetime(0)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">录音开始处理时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">deal_end_time</td>
                        <td align="left" valign="top"><p class="normal">datetime(0)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">录音处理完成时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">create_time</td>
                        <td align="left" valign="top"><p class="normal">datetime(0)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">记录创建时间</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">receive_time</td>
                        <td align="left" valign="top"><p class="normal">datetime(0)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">....</td>
                    </tr>
                    <tr>
                        <td align="left" valign="top"><p class="normal">inc_day</td>
                        <td align="left" valign="top"><p class="normal">varchar(255)</td>
                        <td align="left" valign="top"><p class="normal">YES</td>
                        <td align="left" valign="top"><p class="normal"></td>
                        <td align="left" valign="top"><p class="normal">增量日期</td>
                    </tr>
                </table>
            </div>
        </div>
    </div>
</div>


<script>
    const search_input = document.querySelector("#search-input");
    const search_btn = document.querySelector("#search-button");
    const lis = document.querySelectorAll('li');
    search_btn.onclick = function () {
        const input_str = search_input.value;
        for (let i = 0; i < lis.length; i++) {
            const a = lis[i].querySelector('p>a');
            if (a.innerText.toUpperCase().indexOf(input_str.toUpperCase()) >= 0) {
                lis[i].style.display = '';
            } else {
                lis[i].style.display = 'none';
            }
        }
    }

    window.onload = function () {
        const clientHeight = document.body.clientHeight;
        const headTitle = document.getElementById("title");
        const tables = document.getElementById("tables");
        tables.style.height = (clientHeight - headTitle.offsetHeight) + "px";
        tables.style.overflow = "auto";

        document.onkeydown = function (ev) {
            const event = ev || window.event;
            const key = event.which || event.keyCode || event.charCode;
            if (key == 13) {
                const search_input = document.querySelector("#search-input");
                const search_btn = document.querySelector("#search-button");
                if (search_input == document.activeElement) {
                    search_btn.click();
                }
            }
        }

        const search_input = document.querySelector("#search-input");
        search_input.onkeyup = function () {
            const input_str = search_input.value;
            if (!input_str) {
                const lis = document.querySelectorAll('li');
                for (let i = 0; i < lis.length; i++) {
                    lis[i].style.display = '';
                }
            }
        }

    }

    function scrollTo(id) {
        const elem = document.getElementById(id);
        const tables = document.getElementById("tables");

        tables.scrollTop = elem.offsetTop - 40;
    }

</script>
</body>
</html>